7 Answers · \list or \l : list all databases · \c <db name> : connect to a certain database · \dt : list all tables in the current database using your search_path ... ... <看更多>

You can select the database when connecting with psql. This is handy when using it from a script: sudo -u postgres psql -c "CREATE SCHEMA ... ... <看更多>

PSQL · \? : Show help (list of available commands with an explanation) · \q : Quit/Exit · \c __database__ : Connect to a database · \d __table__ : Show table ... ... <看更多>

Basic Commands · Login to postgresql · Default Admin Login · List databases on postgresql server · Turn off line pager pagination in psql: · Determine system tables. ... <看更多>